Application role permissions should not be assigned to the Oracle PUBLIC role.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-3437	DO0320-ORACLE11	SV-24896r1_rule	DCFA-1	Medium

Description
Application roles have been granted to PUBLIC. Permissions granted to PUBLIC are granted to all users of the database. Custom roles should be used to assign application permissions to functional groups of application users. The installation of Oracle does not assign role permissions to PUBLIC.

STIG	Date
Oracle 11 Database Instance STIG	2014-01-14

Details

Check Text ( None )
None

Fix Text (F-26510r1_fix)
Revoke role grants from PUBLIC. Do not assign role privileges to PUBLIC. From SQL*Plus: revoke [role name] from PUBLIC;